AccountConfigGateway
METADATA
| Attribute | Value |
|---|---|
| Topic | 5120-srse-gateway |
| MLink Token | ConfigGateway |
| Product | SRConfigGateway |
| accessType | SELECT,UPDATE,INSERT,DELETE |
| MLink Endpoint | MLink-Live |
Table Definition
| Field | Type | Key | Default Value | Comment |
|---|---|---|---|---|
| accnt | VARCHAR(16) | PRI | '' | |
| clientFirm | VARCHAR(16) | PRI | '' | |
| accountType | enum - AccountType | 'None' | SR account type | |
| omniAccnt | VARCHAR(16) | '' | omnibus account if any must be an existing account with the same clientFirm and typeOmnibus | |
| omniAccnt2 | VARCHAR(16) | '' | omnibus account if any must be an existing account with the same clientFirm and typeOmnibus | |
| clientAccnt | VARCHAR(32) | '' | client assigned long account string optional used to map between client and SR account strings | |
| clientAccntIds | TEXT | '' | comma separated list of alternate client defined accnt strings that all map to this accountConfig | |
| clientTags | TEXT | '' | optional user defined account tags eg tagtagtagtag max of 10000 total chars including seps | |
| accntName | VARCHAR(32) | '' | account name SR assigned | |
| proxyFirm1 | VARCHAR(16) | '' | proxy firm 1 | |
| proxyFirm2 | VARCHAR(16) | '' | proxy firm 2 | |
| proxyFirm3 | VARCHAR(16) | '' | proxy firm 3 | |
| clientMPID | VARCHAR(4) | '' | ||
| internalMPID | VARCHAR(4) | '' | ||
| execBrkrCode | VARCHAR(16) | '' | ||
| execBrkrAccountStk | VARCHAR(24) | '' | ||
| execBrkrClFirmStk | VARCHAR(24) | '' | ||
| execBrkrAccountFut | VARCHAR(24) | '' | ||
| execBrkrClFirmFut | VARCHAR(24) | '' | ||
| execBrkrAccountOpt | VARCHAR(24) | '' | ||
| execBrkrClFirmOpt | VARCHAR(24) | '' | ||
| reviewBrkrExDestStk | VARCHAR(24) | '' | ||
| reviewBrkrExDestFut | VARCHAR(24) | '' | ||
| reviewBrkrExDestOpt | VARCHAR(24) | '' | ||
| execUserNameStk | VARCHAR(24) | '' | ||
| execUserNameFut | VARCHAR(24) | '' | ||
| execUserNameOpt | VARCHAR(24) | '' | ||
| clearingFirmName | VARCHAR(24) | '' | string name can be anything commonly used by position loaders not used in any FIX message | |
| clearingFirmStk | VARCHAR(4) | '' | stock clearing firm name or code books and records only visible in fix drop templates | |
| clearingAccntStk | VARCHAR(16) | '' | eg C233702 | |
| clearingFirmFut | VARCHAR(4) | '' | futures clearing firm name or code books and records only visible in fix drop templates | |
| clearingAccntFut | VARCHAR(16) | '' | eg C233702 | |
| clearingFirmOpt | VARCHAR(4) | '' | options clearing firm name or code books and records only visible in fix drop templates | |
| clearingAccntOpt | VARCHAR(16) | '' | eg C233701 | |
| clearingFlipTypeOpt | VARCHAR(16) | '' | ||
| clearingFlipFirmOpt | VARCHAR(16) | '' | ||
| clearingFlipAccntOpt | VARCHAR(16) | '' | ||
| stkPositionSrc | enum - PositionSource | 'None' | ||
| futPositionSrc | enum - PositionSource | 'None' | ||
| optPositionSrc | enum - PositionSource | 'None' | ||
| theoModel | VARCHAR(16) | '' | theo model primary | |
| theoModel2 | VARCHAR(16) | '' | theo model 2 | |
| priStkAggGroup | VARCHAR(16) | '' | primary stk grouping code for computing aggregate positions default ClientFirm | |
| secStkAggGroup | VARCHAR(16) | '' | secondary stk grouping code for computing aggregate positions default | |
| optAggGroup | VARCHAR(16) | '' | opt grouping code for computing aggregate positions default ClientFirm | |
| futAggGroup | VARCHAR(16) | '' | fut grouping code for computing aggregate positions default ClientFirm | |
| accntColor | VARCHAR(16) | '' | ||
| accntStatus | enum - AccntStatus | 'None' | This accounts current status | |
| defaultTradingAccnt | VARCHAR(16) | '' | our typeRollup default trading accnt must be typeTrading if ticker not found in AltSymbolMap | |
| mifidAccntId | VARCHAR(16) | '' | MIFID account identifier | |
| catFdidOpenDate | DATE | '1900-01-01' | CAT FDID OpenDate | |
| noCrossGroup | VARCHAR(16) | '' | no cross grouping code accounts with the same nCrossGroup will not cross with themselves default ClientFirm | |
| hedgeDeltaRule | enum - HedgeDeltaRule | 'None' | HedgeDelta Source IVol use SR implied surface sticky strike IvS use SR surface dynamic TVol use user supplied theo surface sticky strike TvS use user supplied theo surface dynamic AccountConfighedgeDelta | |
| binaryDays | FLOAT | 0 | used to force delta calcs binary prior to expiration | |
| awayExecControl | enum - AwayExecControl | 'None' | Whether to include Away Executions in EE risk counters | |
| riskGroupControl | enum - RiskGroupControl | 'None' | enables enhanced risk group controls ParentCapn means each parent order can be at most 1n of the risk group limit StrictLimits implies PC4 | |
| isAtsEnabled | enum - YesNo | 'None' | ||
| clrFlipEnabled | enum - YesNo | 'None' | used to enable brokerdealers to send agency clearing ClrFlip instructions on parent orders | |
| stageReview | enum - StageReview | 'None' | Strict will rereview user changes Normal will rereview size incr only | |
| reviewExDest | VARCHAR(16) | '' | order routing string if any StageReview Orders | |
| userMarking | enum - YesNo | 'None' | users are required to do the longshort marking on orders | |
| requireLocate | enum - RequireLocate | 'None' | locate check enforced in SR systems | |
| locateFirm | VARCHAR(6) | '' | locate firm must be one of the items in the clientFirmConfigLocatePool list | |
| locatePool | VARCHAR(16) | '' | locate pool firm granting the locate | |
| firmType | enum - FirmType | 'None' | ||
| orderCapacity | enum - OrderCapacity | 'None' | Order capacity | |
| custOrderCapacity | enum - OrderCapacity | 'None' | Order capacity of Account at Customers Firm | |
| futClearingRange | enum - FutClearingRange | 'None' | ||
| futCustType | enum - FutCustType | 'None' | ||
| catReportable | enum - CatReportType | 'None' | CAT reportable type | |
| catAccnt | VARCHAR(40) | '' | CAT Firm Designated ID | |
| catBrkrAccnt | VARCHAR(40) | '' | Brkrs CAT Firm Designated ID | |
| catBrkrAccntType | enum - CatAccntType | 'None' | CAT account holder type | |
| catBrkrFirmType | enum - CatFirmType | 'None' | CAT source firm type | |
| catBrkrIMID | VARCHAR(16) | '' | BD firm FDID only if client is a BD supplied by FINRA fbo client | |
| tiedPriceRounding | enum - TiedPriceRounding | 'Loose' | option limit price rounding rule Loose up to 14 tick extra Strict never exceed limit | |
| algoFlashPct | TINYINT UNSIGNED | 0 | percent of orders for which algo will start flash auctions 0 100 | |
| algoBlockPct | TINYINT UNSIGNED | 0 | percent of orders for which algo will start block auctions 0 100 | |
| auctionResponder | enum - AuctionResponder | 'None' | can respond to exchange away auctions | |
| takeExchList | TINYTEXT | '' | exchange order for marketable orders eg BATSNYSECBOE | |
| makeExchList | TINYTEXT | '' | exchange order for nonmarketable orders eg BATSNYSECBOE | |
| incTakeExchFee | enum - IncExchFee | 'None' | include exchange fee in limit calculations | |
| incMakeExchFee | enum - IncExchFee | 'None' | include exchange fee in limit calculations | |
| makeExchRule | enum - MakeExchRule | 'None' | ActiveMaker exchange preference rule MaxPart will pick exchanges to maximize participation FeeOrder will pick exchanges to minimize fees maximize rebates ImprvOnly will only make when improving NBBO | |
| roundRule | enum - RoundRule | 'None' | Stock Price Rounding rule Fuzzy 90 Exact 100 | |
| execMode | enum - ExecMode | 'None' | ||
| cxlOnHalt | enum - YesNo | 'None' | cancel parent orders if the item being traded or underlier is halted | |
| splitZero | enum - YesNo | 'None' | sell stock down to zero before selling short | |
| betaSource | enum - BetaSource | 'None' | ||
| billingSchedule | VARCHAR(16) | '' | overrides billingSchedule at clientFirm level | |
| routeTemplates | TEXT | '' | comma separated list of AccountRouteConfigTemplate IDs | |
| accountConfigRiskTemplate | VARCHAR(32) | '' | AccountConfigRiskTemplate ID | |
| ExchGroupCapStratTemplateNmsEqt | VARCHAR(32) | '' | AccountExchGroupCapStratTemplate ID for NMS EQT configs CapStrategyTable | |
| ExchGroupCapStratTemplateNmsOpt | VARCHAR(32) | '' | AccountExchGroupCapStratTemplate ID for NMS OPT configs CapStrategyTable | |
| ExchGroupCapStratTemplateCmxFut | VARCHAR(32) | '' | AccountExchGroupCapStratTemplate ID for CMX FUT configs CapStrategyTable | |
| ExchGroupRteTemplateNmsEqt | VARCHAR(32) | '' | AccountExchGroupRteTableTemplate ID For NMS EQT configs AccountRouteTable | |
| ExchGroupRteTemplateNmsOpt | VARCHAR(32) | '' | AccountExchGroupRteTableTemplate ID for NMS OPT configs AccountRouteTable | |
| ExchGroupRteTemplateCmxFut | VARCHAR(32) | '' | AccountExchGroupRteTableTemplate ID for CMX FUT configs AccountRouteTable |
PRIMARY KEY DEFINITION (Unique)
| Field | Sequence |
|---|---|
| accnt | 1 |
| clientFirm | 2 |
CREATE TABLE EXAMPLE QUERY
CREATE TABLE `SRConfigGateway`.`MsgAccountConfigGateway` (
`accnt` VARCHAR(16) NOT NULL DEFAULT '',
`clientFirm` VARCHAR(16) NOT NULL DEFAULT '',
`accountType` ENUM('None','Normal','Strategy','Clearing','Rollup','Omnibus','Reconcile') NOT NULL DEFAULT 'None' COMMENT 'SR account type',
`omniAccnt` VARCHAR(16) NOT NULL DEFAULT '' COMMENT 'omnibus account (if any) (must be an existing account with the same clientFirm and type=Omnibus)',
`omniAccnt2` VARCHAR(16) NOT NULL DEFAULT '' COMMENT 'omnibus account (if any) (must be an existing account with the same clientFirm and type=Omnibus)',
`clientAccnt` VARCHAR(32) NOT NULL DEFAULT '' COMMENT 'client assigned "long" account string (optional) [used to map between client and SR account strings]',
`clientAccntIds` TEXT NOT NULL DEFAULT '' COMMENT 'comma separated list of alternate client defined accnt strings that all map to this accountConfig' CHECK(LENGTH(clientAccntIds) <= 10000),
`clientTags` TEXT NOT NULL DEFAULT '' COMMENT '(optional) user defined account tag(s) (eg. tag,tag,tag,tag) [max of 10,000 total chars (including seps)]' CHECK(LENGTH(clientTags) <= 10000),
`accntName` VARCHAR(32) NOT NULL DEFAULT '' COMMENT 'account name (SR assigned)',
`proxyFirm1` VARCHAR(16) NOT NULL DEFAULT '' COMMENT 'proxy firm #1',
`proxyFirm2` VARCHAR(16) NOT NULL DEFAULT '' COMMENT 'proxy firm #2',
`proxyFirm3` VARCHAR(16) NOT NULL DEFAULT '' COMMENT 'proxy firm #3',
`clientMPID` VARCHAR(4) NOT NULL DEFAULT '',
`internalMPID` VARCHAR(4) NOT NULL DEFAULT '',
`execBrkrCode` VARCHAR(16) NOT NULL DEFAULT '',
`execBrkrAccountStk` VARCHAR(24) NOT NULL DEFAULT '',
`execBrkrClFirmStk` VARCHAR(24) NOT NULL DEFAULT '',
`execBrkrAccountFut` VARCHAR(24) NOT NULL DEFAULT '',
`execBrkrClFirmFut` VARCHAR(24) NOT NULL DEFAULT '',
`execBrkrAccountOpt` VARCHAR(24) NOT NULL DEFAULT '',
`execBrkrClFirmOpt` VARCHAR(24) NOT NULL DEFAULT '',
`reviewBrkrExDestStk` VARCHAR(24) NOT NULL DEFAULT '',
`reviewBrkrExDestFut` VARCHAR(24) NOT NULL DEFAULT '',
`reviewBrkrExDestOpt` VARCHAR(24) NOT NULL DEFAULT '',
`execUserNameStk` VARCHAR(24) NOT NULL DEFAULT '',
`execUserNameFut` VARCHAR(24) NOT NULL DEFAULT '',
`execUserNameOpt` VARCHAR(24) NOT NULL DEFAULT '',
`clearingFirmName` VARCHAR(24) NOT NULL DEFAULT '' COMMENT 'string name (can be anything) [commonly used by position loaders] (not used in any FIX message)',
`clearingFirmStk` VARCHAR(4) NOT NULL DEFAULT '' COMMENT 'stock clearing firm name or code [books and records only; visible in fix drop templates]',
`clearingAccntStk` VARCHAR(16) NOT NULL DEFAULT '' COMMENT 'eg C233702',
`clearingFirmFut` VARCHAR(4) NOT NULL DEFAULT '' COMMENT 'futures clearing firm name or code [books and records only; visible in fix drop templates]',
`clearingAccntFut` VARCHAR(16) NOT NULL DEFAULT '' COMMENT 'eg C233702',
`clearingFirmOpt` VARCHAR(4) NOT NULL DEFAULT '' COMMENT 'options clearing firm name or code [books and records only; visible in fix drop templates]',
`clearingAccntOpt` VARCHAR(16) NOT NULL DEFAULT '' COMMENT 'eg C233701',
`clearingFlipTypeOpt` VARCHAR(16) NOT NULL DEFAULT '',
`clearingFlipFirmOpt` VARCHAR(16) NOT NULL DEFAULT '',
`clearingFlipAccntOpt` VARCHAR(16) NOT NULL DEFAULT '',
`stkPositionSrc` ENUM('None','Zero','SR','CLR','CLR_SR') NOT NULL DEFAULT 'None',
`futPositionSrc` ENUM('None','Zero','SR','CLR','CLR_SR') NOT NULL DEFAULT 'None',
`optPositionSrc` ENUM('None','Zero','SR','CLR','CLR_SR') NOT NULL DEFAULT 'None',
`theoModel` VARCHAR(16) NOT NULL DEFAULT '' COMMENT 'theo model (primary)',
`theoModel2` VARCHAR(16) NOT NULL DEFAULT '' COMMENT 'theo model #2',
`priStkAggGroup` VARCHAR(16) NOT NULL DEFAULT '' COMMENT 'primary stk grouping code (for computing aggregate positions) [default = ClientFirm]',
`secStkAggGroup` VARCHAR(16) NOT NULL DEFAULT '' COMMENT 'secondary stk grouping code (for computing aggregate positions) [default = ""]',
`optAggGroup` VARCHAR(16) NOT NULL DEFAULT '' COMMENT 'opt grouping code (for computing aggregate positions) [default = ClientFirm]',
`futAggGroup` VARCHAR(16) NOT NULL DEFAULT '' COMMENT 'fut grouping code (for computing aggregate positions) [default = ClientFirm]',
`accntColor` VARCHAR(16) NOT NULL DEFAULT '',
`accntStatus` ENUM('None','Suspended','Active','Frozen','Pending') NOT NULL DEFAULT 'None' COMMENT 'This accounts current status',
`defaultTradingAccnt` VARCHAR(16) NOT NULL DEFAULT '' COMMENT '[our type=Rollup] default trading accnt (must be type=Trading) (if ticker not found in AltSymbolMap)',
`mifidAccntId` VARCHAR(16) NOT NULL DEFAULT '' COMMENT 'MIFID account identifier',
`catFdidOpenDate` DATE NOT NULL DEFAULT '1900-01-01' COMMENT 'CAT FDID OpenDate',
`noCrossGroup` VARCHAR(16) NOT NULL DEFAULT '' COMMENT 'no cross grouping code (accounts with the same nCrossGroup will not cross with themselves) [default = ClientFirm]',
`hedgeDeltaRule` ENUM('None','IVol','IvS','TVol','TvS','Binary','IvS_25','IvS_50','IvS_75','TvAll','TvAllS') NOT NULL DEFAULT 'None' COMMENT 'HedgeDelta Source (IVol = use SR implied surface (sticky strike), IvS = use SR surface (dynamic), TVol = use user supplied theo surface (sticky strike), TvS = use user supplied theo surface (dynamic)) [AccountConfig.hedgeDelta]',
`binaryDays` FLOAT NOT NULL DEFAULT 0 COMMENT 'used to force delta calcs binary prior to expiration',
`awayExecControl` ENUM('None','IncludeAll') NOT NULL DEFAULT 'None' COMMENT 'Whether to include Away Executions in EE risk counters',
`riskGroupControl` ENUM('None','StrictLimits','ParentCap2','ParentCap3','ParentCap4','Uncapped') NOT NULL DEFAULT 'None' COMMENT 'enables enhanced risk group controls, ParentCap.n means each parent order can be at most 1/n of the risk group limit, StrictLimits implies PC.4',
`isAtsEnabled` ENUM('None','Yes','No') NOT NULL DEFAULT 'None',
`clrFlipEnabled` ENUM('None','Yes','No') NOT NULL DEFAULT 'None' COMMENT 'used to enable broker/dealers to send agency clearing (ClrFlip) instructions on parent orders',
`stageReview` ENUM('None','Strict','Normal') NOT NULL DEFAULT 'None' COMMENT 'Strict will re-review user changes; Normal will re-review size incr only',
`reviewExDest` VARCHAR(16) NOT NULL DEFAULT '' COMMENT 'order routing string (if any) [StageReview Orders]',
`userMarking` ENUM('None','Yes','No') NOT NULL DEFAULT 'None' COMMENT 'users are required to do the long/short marking on orders',
`requireLocate` ENUM('None','Yes','No','Manual','MM','StageReview','Soft') NOT NULL DEFAULT 'None' COMMENT 'locate check enforced in SR systems',
`locateFirm` VARCHAR(6) NOT NULL DEFAULT '' COMMENT 'locate firm [must be one of the items in the clientFirmConfig.LocatePool list]',
`locatePool` VARCHAR(16) NOT NULL DEFAULT '' COMMENT 'locate pool @ firm granting the locate',
`firmType` ENUM('None','Customer','Firm','MarketMaker','ProCustomer','BrokerDealer','AwayMM','FirmJBO','BrkrDlrCust') NOT NULL DEFAULT 'None',
`orderCapacity` ENUM('None','Agency','Principal','Individual','Proprietary','AgentOtherMember','RisklessPrincipal','MarketMaker') NOT NULL DEFAULT 'None' COMMENT 'Order capacity',
`custOrderCapacity` ENUM('None','Agency','Principal','Individual','Proprietary','AgentOtherMember','RisklessPrincipal','MarketMaker') NOT NULL DEFAULT 'None' COMMENT 'Order capacity of Account at Customer''s Firm',
`futClearingRange` ENUM('None','Customer','Firm') NOT NULL DEFAULT 'None',
`futCustType` ENUM('None','IndividualMember','PropMember','OtherMember','NonMember') NOT NULL DEFAULT 'None',
`catReportable` ENUM('None','All','Stock','Options') NOT NULL DEFAULT 'None' COMMENT 'CAT reportable type',
`catAccnt` VARCHAR(40) NOT NULL DEFAULT '' COMMENT 'CAT Firm Designated ID',
`catBrkrAccnt` VARCHAR(40) NOT NULL DEFAULT '' COMMENT 'Brkrs CAT Firm Designated ID',
`catBrkrAccntType` ENUM('None','Institutional','Employee','Foreign','Individual','MktMaking','FirmAvgPx','OtherProp','Error') NOT NULL DEFAULT 'None' COMMENT 'CAT account holder type',
`catBrkrFirmType` ENUM('None','Client','ClientBDAgency','ClientBDFirm','SRFirm') NOT NULL DEFAULT 'None' COMMENT 'CAT source firm type',
`catBrkrIMID` VARCHAR(16) NOT NULL DEFAULT '' COMMENT 'B/D firm FDID (only if client is a B/D) (supplied by FINRA fbo client)',
`tiedPriceRounding` ENUM('Loose','Strict') NOT NULL DEFAULT 'Loose' COMMENT 'option limit price rounding rule: Loose = up to 1/4 tick extra; Strict = never exceed limit',
`algoFlashPct` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'percent of orders for which algo will start flash auctions [0 - 100]',
`algoBlockPct` TINYINT UNSIGNED NOT NULL DEFAULT 0 COMMENT 'percent of orders for which algo will start block auctions [0 - 100]',
`auctionResponder` ENUM('None','Any') NOT NULL DEFAULT 'None' COMMENT 'can respond to exchange / away auctions',
`takeExchList` TINYTEXT NOT NULL DEFAULT '' COMMENT 'exchange order for marketable orders eg: BATS,NYSE,CBOE',
`makeExchList` TINYTEXT NOT NULL DEFAULT '' COMMENT 'exchange order for non-marketable orders eg: BATS,NYSE,CBOE',
`incTakeExchFee` ENUM('None','ExclFee','IncFee') NOT NULL DEFAULT 'None' COMMENT 'include exchange fee in limit calculations',
`incMakeExchFee` ENUM('None','ExclFee','IncFee') NOT NULL DEFAULT 'None' COMMENT 'include exchange fee in limit calculations',
`makeExchRule` ENUM('None','MaxPart','FeeOptimal','ImprvOnly','FeeStrict','RoundRobin','ProRataOptim') NOT NULL DEFAULT 'None' COMMENT 'ActiveMaker exchange preference rule: ''MaxPart'' will pick exchanges to maximize participation; ''FeeOrder'' will pick exchanges to minimize fees [maximize rebates]; ''ImprvOnly'' will only make when improving NBBO.',
`roundRule` ENUM('None','Exact','Fuzzy') NOT NULL DEFAULT 'None' COMMENT 'Stock Price Rounding rule (Fuzzy = 90%, Exact = 100%)',
`execMode` ENUM('None','OptimizePnL','OptimizeFees') NOT NULL DEFAULT 'None',
`cxlOnHalt` ENUM('None','Yes','No') NOT NULL DEFAULT 'None' COMMENT 'cancel parent orders if the item being traded (or underlier) is halted',
`splitZero` ENUM('None','Yes','No') NOT NULL DEFAULT 'None' COMMENT 'sell stock down to zero before selling short',
`betaSource` ENUM('None','betaSPX','betaQQQ','betaIWM','clientBeta') NOT NULL DEFAULT 'None',
`billingSchedule` VARCHAR(16) NOT NULL DEFAULT '' COMMENT 'overrides billingSchedule at clientFirm level',
`routeTemplates` TEXT NOT NULL DEFAULT '' COMMENT 'comma separated list of AccountRouteConfigTemplate IDs' CHECK(LENGTH(routeTemplates) <= 10000),
`accountConfigRiskTemplate` VARCHAR(32) NOT NULL DEFAULT '' COMMENT 'AccountConfigRiskTemplate ID',
`ExchGroupCapStratTemplateNmsEqt` VARCHAR(32) NOT NULL DEFAULT '' COMMENT 'AccountExchGroupCapStratTemplate ID for NMS EQT config''s CapStrategyTable',
`ExchGroupCapStratTemplateNmsOpt` VARCHAR(32) NOT NULL DEFAULT '' COMMENT 'AccountExchGroupCapStratTemplate ID for NMS OPT config''s CapStrategyTable',
`ExchGroupCapStratTemplateCmxFut` VARCHAR(32) NOT NULL DEFAULT '' COMMENT 'AccountExchGroupCapStratTemplate ID for CMX FUT config''s CapStrategyTable',
`ExchGroupRteTemplateNmsEqt` VARCHAR(32) NOT NULL DEFAULT '' COMMENT 'AccountExchGroupRteTableTemplate ID For NMS EQT config''s AccountRouteTable',
`ExchGroupRteTemplateNmsOpt` VARCHAR(32) NOT NULL DEFAULT '' COMMENT 'AccountExchGroupRteTableTemplate ID for NMS OPT config''s AccountRouteTable',
`ExchGroupRteTemplateCmxFut` VARCHAR(32) NOT NULL DEFAULT '' COMMENT 'AccountExchGroupRteTableTemplate ID for CMX FUT config''s AccountRouteTable',
PRIMARY KEY USING HASH (`accnt`,`clientFirm`)
) ENGINE=SRSE DEFAULT CHARSET=LATIN1 COMMENT='';
SELECT TABLE EXAMPLE QUERY
SELECT
`accnt`,
`clientFirm`,
`accountType`,
`omniAccnt`,
`omniAccnt2`,
`clientAccnt`,
`clientAccntIds`,
`clientTags`,
`accntName`,
`proxyFirm1`,
`proxyFirm2`,
`proxyFirm3`,
`clientMPID`,
`internalMPID`,
`execBrkrCode`,
`execBrkrAccountStk`,
`execBrkrClFirmStk`,
`execBrkrAccountFut`,
`execBrkrClFirmFut`,
`execBrkrAccountOpt`,
`execBrkrClFirmOpt`,
`reviewBrkrExDestStk`,
`reviewBrkrExDestFut`,
`reviewBrkrExDestOpt`,
`execUserNameStk`,
`execUserNameFut`,
`execUserNameOpt`,
`clearingFirmName`,
`clearingFirmStk`,
`clearingAccntStk`,
`clearingFirmFut`,
`clearingAccntFut`,
`clearingFirmOpt`,
`clearingAccntOpt`,
`clearingFlipTypeOpt`,
`clearingFlipFirmOpt`,
`clearingFlipAccntOpt`,
`stkPositionSrc`,
`futPositionSrc`,
`optPositionSrc`,
`theoModel`,
`theoModel2`,
`priStkAggGroup`,
`secStkAggGroup`,
`optAggGroup`,
`futAggGroup`,
`accntColor`,
`accntStatus`,
`defaultTradingAccnt`,
`mifidAccntId`,
`catFdidOpenDate`,
`noCrossGroup`,
`hedgeDeltaRule`,
`binaryDays`,
`awayExecControl`,
`riskGroupControl`,
`isAtsEnabled`,
`clrFlipEnabled`,
`stageReview`,
`reviewExDest`,
`userMarking`,
`requireLocate`,
`locateFirm`,
`locatePool`,
`firmType`,
`orderCapacity`,
`custOrderCapacity`,
`futClearingRange`,
`futCustType`,
`catReportable`,
`catAccnt`,
`catBrkrAccnt`,
`catBrkrAccntType`,
`catBrkrFirmType`,
`catBrkrIMID`,
`tiedPriceRounding`,
`algoFlashPct`,
`algoBlockPct`,
`auctionResponder`,
`takeExchList`,
`makeExchList`,
`incTakeExchFee`,
`incMakeExchFee`,
`makeExchRule`,
`roundRule`,
`execMode`,
`cxlOnHalt`,
`splitZero`,
`betaSource`,
`billingSchedule`,
`routeTemplates`,
`accountConfigRiskTemplate`,
`ExchGroupCapStratTemplateNmsEqt`,
`ExchGroupCapStratTemplateNmsOpt`,
`ExchGroupCapStratTemplateCmxFut`,
`ExchGroupRteTemplateNmsEqt`,
`ExchGroupRteTemplateNmsOpt`,
`ExchGroupRteTemplateCmxFut`
FROM `SRConfigGateway`.`MsgAccountConfigGateway`
WHERE
/* Replace with a VARCHAR(16) */
`accnt` = 'Example_accnt'
AND
/* Replace with a VARCHAR(16) */
`clientFirm` = 'Example_clientFirm';
UPDATE TABLE EXAMPLE QUERY
UPDATE `SRConfigGateway`.`MsgAccountConfigGateway`
SET
/* Replace with a ENUM('None','Normal','Strategy','Clearing','Rollup','Omnibus','Reconcile') */
`accountType` = 'None',
/* Replace with a VARCHAR(16) */
`omniAccnt` = 'Example_omniAccnt',
/* Replace with a VARCHAR(16) */
`omniAccnt2` = 'Example_omniAccnt2',
/* Replace with a VARCHAR(32) */
`clientAccnt` = 'Example_clientAccnt',
/* Replace with a TEXT */
`clientAccntIds` = 'dummy text',
/* Replace with a TEXT */
`clientTags` = 'dummy text',
/* Replace with a VARCHAR(32) */
`accntName` = 'Example_accntName',
/* Replace with a VARCHAR(16) */
`proxyFirm1` = 'Example_proxyFirm1',
/* Replace with a VARCHAR(16) */
`proxyFirm2` = 'Example_proxyFirm2',
/* Replace with a VARCHAR(16) */
`proxyFirm3` = 'Example_proxyFirm3',
/* Replace with a VARCHAR(4) */
`clientMPID` = 'Example_clientMPID',
/* Replace with a VARCHAR(4) */
`internalMPID` = 'Example_internalMPID',
/* Replace with a VARCHAR(16) */
`execBrkrCode` = 'Example_execBrkrCode',
/* Replace with a VARCHAR(24) */
`execBrkrAccountStk` = 'Example_execBrkrAccountStk',
/* Replace with a VARCHAR(24) */
`execBrkrClFirmStk` = 'Example_execBrkrClFirmStk',
/* Replace with a VARCHAR(24) */
`execBrkrAccountFut` = 'Example_execBrkrAccountFut',
/* Replace with a VARCHAR(24) */
`execBrkrClFirmFut` = 'Example_execBrkrClFirmFut',
/* Replace with a VARCHAR(24) */
`execBrkrAccountOpt` = 'Example_execBrkrAccountOpt',
/* Replace with a VARCHAR(24) */
`execBrkrClFirmOpt` = 'Example_execBrkrClFirmOpt',
/* Replace with a VARCHAR(24) */
`reviewBrkrExDestStk` = 'Example_reviewBrkrExDestStk',
/* Replace with a VARCHAR(24) */
`reviewBrkrExDestFut` = 'Example_reviewBrkrExDestFut',
/* Replace with a VARCHAR(24) */
`reviewBrkrExDestOpt` = 'Example_reviewBrkrExDestOpt',
/* Replace with a VARCHAR(24) */
`execUserNameStk` = 'Example_execUserNameStk',
/* Replace with a VARCHAR(24) */
`execUserNameFut` = 'Example_execUserNameFut',
/* Replace with a VARCHAR(24) */
`execUserNameOpt` = 'Example_execUserNameOpt',
/* Replace with a VARCHAR(24) */
`clearingFirmName` = 'Example_clearingFirmName',
/* Replace with a VARCHAR(4) */
`clearingFirmStk` = 'Example_clearingFirmStk',
/* Replace with a VARCHAR(16) */
`clearingAccntStk` = 'Example_clearingAccntStk',
/* Replace with a VARCHAR(4) */
`clearingFirmFut` = 'Example_clearingFirmFut',
/* Replace with a VARCHAR(16) */
`clearingAccntFut` = 'Example_clearingAccntFut',
/* Replace with a VARCHAR(4) */
`clearingFirmOpt` = 'Example_clearingFirmOpt',
/* Replace with a VARCHAR(16) */
`clearingAccntOpt` = 'Example_clearingAccntOpt',
/* Replace with a VARCHAR(16) */
`clearingFlipTypeOpt` = 'Example_clearingFlipTypeOpt',
/* Replace with a VARCHAR(16) */
`clearingFlipFirmOpt` = 'Example_clearingFlipFirmOpt',
/* Replace with a VARCHAR(16) */
`clearingFlipAccntOpt` = 'Example_clearingFlipAccntOpt',
/* Replace with a ENUM('None','Zero','SR','CLR','CLR_SR') */
`stkPositionSrc` = 'None',
/* Replace with a ENUM('None','Zero','SR','CLR','CLR_SR') */
`futPositionSrc` = 'None',
/* Replace with a ENUM('None','Zero','SR','CLR','CLR_SR') */
`optPositionSrc` = 'None',
/* Replace with a VARCHAR(16) */
`theoModel` = 'Example_theoModel',
/* Replace with a VARCHAR(16) */
`theoModel2` = 'Example_theoModel2',
/* Replace with a VARCHAR(16) */
`priStkAggGroup` = 'Example_priStkAggGroup',
/* Replace with a VARCHAR(16) */
`secStkAggGroup` = 'Example_secStkAggGroup',
/* Replace with a VARCHAR(16) */
`optAggGroup` = 'Example_optAggGroup',
/* Replace with a VARCHAR(16) */
`futAggGroup` = 'Example_futAggGroup',
/* Replace with a VARCHAR(16) */
`accntColor` = 'Example_accntColor',
/* Replace with a ENUM('None','Suspended','Active','Frozen','Pending') */
`accntStatus` = 'None',
/* Replace with a VARCHAR(16) */
`defaultTradingAccnt` = 'Example_defaultTradingAccnt',
/* Replace with a VARCHAR(16) */
`mifidAccntId` = 'Example_mifidAccntId',
/* Replace with a DATE */
`catFdidOpenDate` = '2022-01-01',
/* Replace with a VARCHAR(16) */
`noCrossGroup` = 'Example_noCrossGroup',
/* Replace with a ENUM('None','IVol','IvS','TVol','TvS','Binary','IvS_25','IvS_50','IvS_75','TvAll','TvAllS') */
`hedgeDeltaRule` = 'None',
/* Replace with a FLOAT */
`binaryDays` = 1.23,
/* Replace with a ENUM('None','IncludeAll') */
`awayExecControl` = 'None',
/* Replace with a ENUM('None','StrictLimits','ParentCap2','ParentCap3','ParentCap4','Uncapped') */
`riskGroupControl` = 'None',
/* Replace with a ENUM('None','Yes','No') */
`isAtsEnabled` = 'None',
/* Replace with a ENUM('None','Yes','No') */
`clrFlipEnabled` = 'None',
/* Replace with a ENUM('None','Strict','Normal') */
`stageReview` = 'None',
/* Replace with a VARCHAR(16) */
`reviewExDest` = 'Example_reviewExDest',
/* Replace with a ENUM('None','Yes','No') */
`userMarking` = 'None',
/* Replace with a ENUM('None','Yes','No','Manual','MM','StageReview','Soft') */
`requireLocate` = 'None',
/* Replace with a VARCHAR(6) */
`locateFirm` = 'Example_locateFirm',
/* Replace with a VARCHAR(16) */
`locatePool` = 'Example_locatePool',
/* Replace with a ENUM('None','Customer','Firm','MarketMaker','ProCustomer','BrokerDealer','AwayMM','FirmJBO','BrkrDlrCust') */
`firmType` = 'None',
/* Replace with a ENUM('None','Agency','Principal','Individual','Proprietary','AgentOtherMember','RisklessPrincipal','MarketMaker') */
`orderCapacity` = 'None',
/* Replace with a ENUM('None','Agency','Principal','Individual','Proprietary','AgentOtherMember','RisklessPrincipal','MarketMaker') */
`custOrderCapacity` = 'None',
/* Replace with a ENUM('None','Customer','Firm') */
`futClearingRange` = 'None',
/* Replace with a ENUM('None','IndividualMember','PropMember','OtherMember','NonMember') */
`futCustType` = 'None',
/* Replace with a ENUM('None','All','Stock','Options') */
`catReportable` = 'None',
/* Replace with a VARCHAR(40) */
`catAccnt` = 'Example_catAccnt',
/* Replace with a VARCHAR(40) */
`catBrkrAccnt` = 'Example_catBrkrAccnt',
/* Replace with a ENUM('None','Institutional','Employee','Foreign','Individual','MktMaking','FirmAvgPx','OtherProp','Error') */
`catBrkrAccntType` = 'None',
/* Replace with a ENUM('None','Client','ClientBDAgency','ClientBDFirm','SRFirm') */
`catBrkrFirmType` = 'None',
/* Replace with a VARCHAR(16) */
`catBrkrIMID` = 'Example_catBrkrIMID',
/* Replace with a ENUM('Loose','Strict') */
`tiedPriceRounding` = 'Loose',
/* Replace with a TINYINT UNSIGNED */
`algoFlashPct` = 1,
/* Replace with a TINYINT UNSIGNED */
`algoBlockPct` = 1,
/* Replace with a ENUM('None','Any') */
`auctionResponder` = 'None',
/* Replace with a TINYTEXT */
`takeExchList` = 'dummy tiny text',
/* Replace with a TINYTEXT */
`makeExchList` = 'dummy tiny text',
/* Replace with a ENUM('None','ExclFee','IncFee') */
`incTakeExchFee` = 'None',
/* Replace with a ENUM('None','ExclFee','IncFee') */
`incMakeExchFee` = 'None',
/* Replace with a ENUM('None','MaxPart','FeeOptimal','ImprvOnly','FeeStrict','RoundRobin','ProRataOptim') */
`makeExchRule` = 'None',
/* Replace with a ENUM('None','Exact','Fuzzy') */
`roundRule` = 'None',
/* Replace with a ENUM('None','OptimizePnL','OptimizeFees') */
`execMode` = 'None',
/* Replace with a ENUM('None','Yes','No') */
`cxlOnHalt` = 'None',
/* Replace with a ENUM('None','Yes','No') */
`splitZero` = 'None',
/* Replace with a ENUM('None','betaSPX','betaQQQ','betaIWM','clientBeta') */
`betaSource` = 'None',
/* Replace with a VARCHAR(16) */
`billingSchedule` = 'Example_billingSchedule',
/* Replace with a TEXT */
`routeTemplates` = 'dummy text',
/* Replace with a VARCHAR(32) */
`accountConfigRiskTemplate` = 'Example_accountConfigRiskTemplate',
/* Replace with a VARCHAR(32) */
`ExchGroupCapStratTemplateNmsEqt` = 'Example_ExchGroupCapStratTemplateNmsEqt',
/* Replace with a VARCHAR(32) */
`ExchGroupCapStratTemplateNmsOpt` = 'Example_ExchGroupCapStratTemplateNmsOpt',
/* Replace with a VARCHAR(32) */
`ExchGroupCapStratTemplateCmxFut` = 'Example_ExchGroupCapStratTemplateCmxFut',
/* Replace with a VARCHAR(32) */
`ExchGroupRteTemplateNmsEqt` = 'Example_ExchGroupRteTemplateNmsEqt',
/* Replace with a VARCHAR(32) */
`ExchGroupRteTemplateNmsOpt` = 'Example_ExchGroupRteTemplateNmsOpt',
/* Replace with a VARCHAR(32) */
`ExchGroupRteTemplateCmxFut` = 'Example_ExchGroupRteTemplateCmxFut'
WHERE
/* Replace with a VARCHAR(16) */
`accnt` = 'Example_accnt'
AND
/* Replace with a VARCHAR(16) */
`clientFirm` = 'Example_clientFirm';
INSERT TABLE EXAMPLE QUERY
INSERT INTO `SRConfigGateway`.`MsgAccountConfigGateway`(
/* Replace with a VARCHAR(16) */
`accnt`,
/* Replace with a VARCHAR(16) */
`clientFirm`,
/* Replace with a ENUM('None','Normal','Strategy','Clearing','Rollup','Omnibus','Reconcile') */
`accountType`,
/* Replace with a VARCHAR(16) */
`omniAccnt`,
/* Replace with a VARCHAR(16) */
`omniAccnt2`,
/* Replace with a VARCHAR(32) */
`clientAccnt`,
/* Replace with a TEXT */
`clientAccntIds`,
/* Replace with a TEXT */
`clientTags`,
/* Replace with a VARCHAR(32) */
`accntName`,
/* Replace with a VARCHAR(16) */
`proxyFirm1`,
/* Replace with a VARCHAR(16) */
`proxyFirm2`,
/* Replace with a VARCHAR(16) */
`proxyFirm3`,
/* Replace with a VARCHAR(4) */
`clientMPID`,
/* Replace with a VARCHAR(4) */
`internalMPID`,
/* Replace with a VARCHAR(16) */
`execBrkrCode`,
/* Replace with a VARCHAR(24) */
`execBrkrAccountStk`,
/* Replace with a VARCHAR(24) */
`execBrkrClFirmStk`,
/* Replace with a VARCHAR(24) */
`execBrkrAccountFut`,
/* Replace with a VARCHAR(24) */
`execBrkrClFirmFut`,
/* Replace with a VARCHAR(24) */
`execBrkrAccountOpt`,
/* Replace with a VARCHAR(24) */
`execBrkrClFirmOpt`,
/* Replace with a VARCHAR(24) */
`reviewBrkrExDestStk`,
/* Replace with a VARCHAR(24) */
`reviewBrkrExDestFut`,
/* Replace with a VARCHAR(24) */
`reviewBrkrExDestOpt`,
/* Replace with a VARCHAR(24) */
`execUserNameStk`,
/* Replace with a VARCHAR(24) */
`execUserNameFut`,
/* Replace with a VARCHAR(24) */
`execUserNameOpt`,
/* Replace with a VARCHAR(24) */
`clearingFirmName`,
/* Replace with a VARCHAR(4) */
`clearingFirmStk`,
/* Replace with a VARCHAR(16) */
`clearingAccntStk`,
/* Replace with a VARCHAR(4) */
`clearingFirmFut`,
/* Replace with a VARCHAR(16) */
`clearingAccntFut`,
/* Replace with a VARCHAR(4) */
`clearingFirmOpt`,
/* Replace with a VARCHAR(16) */
`clearingAccntOpt`,
/* Replace with a VARCHAR(16) */
`clearingFlipTypeOpt`,
/* Replace with a VARCHAR(16) */
`clearingFlipFirmOpt`,
/* Replace with a VARCHAR(16) */
`clearingFlipAccntOpt`,
/* Replace with a ENUM('None','Zero','SR','CLR','CLR_SR') */
`stkPositionSrc`,
/* Replace with a ENUM('None','Zero','SR','CLR','CLR_SR') */
`futPositionSrc`,
/* Replace with a ENUM('None','Zero','SR','CLR','CLR_SR') */
`optPositionSrc`,
/* Replace with a VARCHAR(16) */
`theoModel`,
/* Replace with a VARCHAR(16) */
`theoModel2`,
/* Replace with a VARCHAR(16) */
`priStkAggGroup`,
/* Replace with a VARCHAR(16) */
`secStkAggGroup`,
/* Replace with a VARCHAR(16) */
`optAggGroup`,
/* Replace with a VARCHAR(16) */
`futAggGroup`,
/* Replace with a VARCHAR(16) */
`accntColor`,
/* Replace with a ENUM('None','Suspended','Active','Frozen','Pending') */
`accntStatus`,
/* Replace with a VARCHAR(16) */
`defaultTradingAccnt`,
/* Replace with a VARCHAR(16) */
`mifidAccntId`,
/* Replace with a DATE */
`catFdidOpenDate`,
/* Replace with a VARCHAR(16) */
`noCrossGroup`,
/* Replace with a ENUM('None','IVol','IvS','TVol','TvS','Binary','IvS_25','IvS_50','IvS_75','TvAll','TvAllS') */
`hedgeDeltaRule`,
/* Replace with a FLOAT */
`binaryDays`,
/* Replace with a ENUM('None','IncludeAll') */
`awayExecControl`,
/* Replace with a ENUM('None','StrictLimits','ParentCap2','ParentCap3','ParentCap4','Uncapped') */
`riskGroupControl`,
/* Replace with a ENUM('None','Yes','No') */
`isAtsEnabled`,
/* Replace with a ENUM('None','Yes','No') */
`clrFlipEnabled`,
/* Replace with a ENUM('None','Strict','Normal') */
`stageReview`,
/* Replace with a VARCHAR(16) */
`reviewExDest`,
/* Replace with a ENUM('None','Yes','No') */
`userMarking`,
/* Replace with a ENUM('None','Yes','No','Manual','MM','StageReview','Soft') */
`requireLocate`,
/* Replace with a VARCHAR(6) */
`locateFirm`,
/* Replace with a VARCHAR(16) */
`locatePool`,
/* Replace with a ENUM('None','Customer','Firm','MarketMaker','ProCustomer','BrokerDealer','AwayMM','FirmJBO','BrkrDlrCust') */
`firmType`,
/* Replace with a ENUM('None','Agency','Principal','Individual','Proprietary','AgentOtherMember','RisklessPrincipal','MarketMaker') */
`orderCapacity`,
/* Replace with a ENUM('None','Agency','Principal','Individual','Proprietary','AgentOtherMember','RisklessPrincipal','MarketMaker') */
`custOrderCapacity`,
/* Replace with a ENUM('None','Customer','Firm') */
`futClearingRange`,
/* Replace with a ENUM('None','IndividualMember','PropMember','OtherMember','NonMember') */
`futCustType`,
/* Replace with a ENUM('None','All','Stock','Options') */
`catReportable`,
/* Replace with a VARCHAR(40) */
`catAccnt`,
/* Replace with a VARCHAR(40) */
`catBrkrAccnt`,
/* Replace with a ENUM('None','Institutional','Employee','Foreign','Individual','MktMaking','FirmAvgPx','OtherProp','Error') */
`catBrkrAccntType`,
/* Replace with a ENUM('None','Client','ClientBDAgency','ClientBDFirm','SRFirm') */
`catBrkrFirmType`,
/* Replace with a VARCHAR(16) */
`catBrkrIMID`,
/* Replace with a ENUM('Loose','Strict') */
`tiedPriceRounding`,
/* Replace with a TINYINT UNSIGNED */
`algoFlashPct`,
/* Replace with a TINYINT UNSIGNED */
`algoBlockPct`,
/* Replace with a ENUM('None','Any') */
`auctionResponder`,
/* Replace with a TINYTEXT */
`takeExchList`,
/* Replace with a TINYTEXT */
`makeExchList`,
/* Replace with a ENUM('None','ExclFee','IncFee') */
`incTakeExchFee`,
/* Replace with a ENUM('None','ExclFee','IncFee') */
`incMakeExchFee`,
/* Replace with a ENUM('None','MaxPart','FeeOptimal','ImprvOnly','FeeStrict','RoundRobin','ProRataOptim') */
`makeExchRule`,
/* Replace with a ENUM('None','Exact','Fuzzy') */
`roundRule`,
/* Replace with a ENUM('None','OptimizePnL','OptimizeFees') */
`execMode`,
/* Replace with a ENUM('None','Yes','No') */
`cxlOnHalt`,
/* Replace with a ENUM('None','Yes','No') */
`splitZero`,
/* Replace with a ENUM('None','betaSPX','betaQQQ','betaIWM','clientBeta') */
`betaSource`,
/* Replace with a VARCHAR(16) */
`billingSchedule`,
/* Replace with a TEXT */
`routeTemplates`,
/* Replace with a VARCHAR(32) */
`accountConfigRiskTemplate`,
/* Replace with a VARCHAR(32) */
`ExchGroupCapStratTemplateNmsEqt`,
/* Replace with a VARCHAR(32) */
`ExchGroupCapStratTemplateNmsOpt`,
/* Replace with a VARCHAR(32) */
`ExchGroupCapStratTemplateCmxFut`,
/* Replace with a VARCHAR(32) */
`ExchGroupRteTemplateNmsEqt`,
/* Replace with a VARCHAR(32) */
`ExchGroupRteTemplateNmsOpt`,
/* Replace with a VARCHAR(32) */
`ExchGroupRteTemplateCmxFut`
)
VALUES(
'Example_accnt',
'Example_clientFirm',
'None',
'Example_omniAccnt',
'Example_omniAccnt2',
'Example_clientAccnt',
'dummy text',
'dummy text',
'Example_accntName',
'Example_proxyFirm1',
'Example_proxyFirm2',
'Example_proxyFirm3',
'Example_clientMPID',
'Example_internalMPID',
'Example_execBrkrCode',
'Example_execBrkrAccountStk',
'Example_execBrkrClFirmStk',
'Example_execBrkrAccountFut',
'Example_execBrkrClFirmFut',
'Example_execBrkrAccountOpt',
'Example_execBrkrClFirmOpt',
'Example_reviewBrkrExDestStk',
'Example_reviewBrkrExDestFut',
'Example_reviewBrkrExDestOpt',
'Example_execUserNameStk',
'Example_execUserNameFut',
'Example_execUserNameOpt',
'Example_clearingFirmName',
'Example_clearingFirmStk',
'Example_clearingAccntStk',
'Example_clearingFirmFut',
'Example_clearingAccntFut',
'Example_clearingFirmOpt',
'Example_clearingAccntOpt',
'Example_clearingFlipTypeOpt',
'Example_clearingFlipFirmOpt',
'Example_clearingFlipAccntOpt',
'None',
'None',
'None',
'Example_theoModel',
'Example_theoModel2',
'Example_priStkAggGroup',
'Example_secStkAggGroup',
'Example_optAggGroup',
'Example_futAggGroup',
'Example_accntColor',
'None',
'Example_defaultTradingAccnt',
'Example_mifidAccntId',
'2022-01-01',
'Example_noCrossGroup',
'None',
1.23,
'None',
'None',
'None',
'None',
'None',
'Example_reviewExDest',
'None',
'None',
'Example_locateFirm',
'Example_locatePool',
'None',
'None',
'None',
'None',
'None',
'None',
'Example_catAccnt',
'Example_catBrkrAccnt',
'None',
'None',
'Example_catBrkrIMID',
'Loose',
1,
1,
'None',
'dummy tiny text',
'dummy tiny text',
'None',
'None',
'None',
'None',
'None',
'None',
'None',
'None',
'Example_billingSchedule',
'dummy text',
'Example_accountConfigRiskTemplate',
'Example_ExchGroupCapStratTemplateNmsEqt',
'Example_ExchGroupCapStratTemplateNmsOpt',
'Example_ExchGroupCapStratTemplateCmxFut',
'Example_ExchGroupRteTemplateNmsEqt',
'Example_ExchGroupRteTemplateNmsOpt',
'Example_ExchGroupRteTemplateCmxFut'
);
DELETE TABLE EXAMPLE QUERY
DELETE FROM `SRConfigGateway`.`MsgAccountConfigGateway`
WHERE
/* Replace with a VARCHAR(16) */
`accnt` = 'Example_accnt'
AND
/* Replace with a VARCHAR(16) */
`clientFirm` = 'Example_clientFirm';
Doc Columns Query
SELECT * FROM SRConfigGateway.doccolumns WHERE TABLE_NAME='AccountConfigGateway' ORDER BY ordinal_position ASC;